"""
select a.id from
(select id, recordDate, addDate(recordDate, -1) as lastdate , Temperature from Weather) a join Weather b
on
a.lastdate = b.recordDate and a.Temperature > b.Temperature
"""